---------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /volumes/ddisk/math/soviet/Table_1.log
  log type:  text
 opened on:  23 Mar 2014, 08:03:59

. *SET 1: SOVIET PAPERS FROM AUTHOR-YEAR DATA;
. use "/volumes/ddisk/math/ams/clean_ams_data_author_year.dta", clear;

. generate good=.;
(6282565 missing values generated)

. replace good=1 if year>=1970 & year<=1989;
(2433275 real changes made)

. egen n70=sum(good*papers), by(unique);

. drop if n70==0;
(675205 observations deleted)

. merge unique using "/volumes/ddisk/math/ams/international/soviet_universe.dta";
(note: you are using old merge syntax; see [D] merge for new syntax)
variable unique does not uniquely identify observations in the master data
degree_year was int now float

. drop _merge;

. keep if soviet==1;
(5243145 observations deleted)

. drop country;

. rename modal_country country;

. keep if year>=1982 & year<=2008;
(54105 observations deleted)

. replace good=.;
(78207 real changes made, 78207 to missing)

. replace good=1 if year>=1985 & year<=1989;
(54286 real changes made)

. egen n85=sum(good*papers), by(unique);

. replace n85=(n85>0);
(201761 real changes made)

. replace emigre=0 if emigre==.;
(0 real changes made)

. collapse (sum) papers citations_ams (mean) minyear emigre n85, by(unique post1992);

. sort post1992;

. by post1992: sum papers if emigre==0, detail;

---------------------------------------------------------------------------------------------------
-> post1992 = 0

                        (sum) papers
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1              0
 5%            1              0
10%            1              0       Obs               11173
25%            2              0       Sum of Wgt.       11173

50%            4                      Mean           6.323369
                        Largest       Std. Dev.      8.057064
75%            8            102
90%           15            102       Variance       64.91628
95%           20            138       Skewness       4.629775
99%           38            153       Kurtosis       43.68858

---------------------------------------------------------------------------------------------------
-> post1992 = 1

                        (sum) papers
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs               11173
25%            0              0       Sum of Wgt.       11173

50%            1                      Mean           7.633223
                        Largest       Std. Dev.      15.84047
75%            8            213
90%           24            214       Variance       250.9206
95%           37            221       Skewness       4.736235
99%           72            311       Kurtosis       42.27947


. by post1992: sum citations_ams if emigre==0, detail;

---------------------------------------------------------------------------------------------------
-> post1992 = 0

                     (sum) citations_ams
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs               11173
25%            0              0       Sum of Wgt.       11173

50%            0                      Mean           6.729885
                        Largest       Std. Dev.       41.3918
75%            2            707
90%           10            811       Variance       1713.281
95%           27           1932       Skewness       27.60545
99%          124           2240       Kurtosis       1229.975

---------------------------------------------------------------------------------------------------
-> post1992 = 1

                     (sum) citations_ams
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs               11173
25%            0              0       Sum of Wgt.       11173

50%            0                      Mean           13.38897
                        Largest       Std. Dev.      58.09975
75%            2           1165
90%           26           1228       Variance       3375.581
95%           70           1233       Skewness       9.999001
99%          257           1287       Kurtosis       146.0351


. by post1992: sum papers if emigre==1, detail;

---------------------------------------------------------------------------------------------------
-> post1992 = 0

                        (sum) papers
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1              1
 5%            1              1
10%            2              1       Obs                1051
25%            4              1       Sum of Wgt.        1051

50%           10                      Mean           12.79163
                        Largest       Std. Dev.      11.96548
75%           17             79
90%           27             81       Variance       143.1727
95%           34             86       Skewness       2.253422
99%           60             90       Kurtosis       10.67295

---------------------------------------------------------------------------------------------------
-> post1992 = 1

                        (sum) papers
-------------------------------------------------------------
      Percentiles      Smallest
 1%            1              1
 5%            1              1
10%            3              1       Obs                1051
25%            8              1       Sum of Wgt.        1051

50%           21                      Mean           28.29591
                        Largest       Std. Dev.      28.85347
75%           40            195
90%           60            233       Variance       832.5228
95%           76            262       Skewness       3.036017
99%          128            317       Kurtosis       21.24095


. by post1992: sum citations_ams if emigre==1, detail;

---------------------------------------------------------------------------------------------------
-> post1992 = 0

                     (sum) citations_ams
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs                1051
25%            1              0       Sum of Wgt.        1051

50%            6                      Mean           38.46908
                        Largest       Std. Dev.      105.1184
75%           29            968
90%           98           1081       Variance       11049.88
95%          187           1137       Skewness       6.461886
99%          423           1256       Kurtosis       57.00154

---------------------------------------------------------------------------------------------------
-> post1992 = 1

                     (sum) citations_ams
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs                1051
25%            5              0       Sum of Wgt.        1051

50%           44                      Mean           131.7479
                        Largest       Std. Dev.      219.9938
75%          169           1543
90%          377           1544       Variance       48397.26
95%          548           1709       Skewness       3.304115
99%         1067           1988       Kurtosis       18.01941


. log close;
      name:  <unnamed>
       log:  /volumes/ddisk/math/soviet/Table_1.log
  log type:  text
 closed on:  23 Mar 2014, 08:04:16
---------------------------------------------------------------------------------------------------
